Profiling Report

Dataset statistics

Number of variables	13
Number of observations	1000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	5
Duplicate rows (%)	0.5%
Total size in memory	101.7 KiB
Average record size in memory	104.1 B

Variable types

Categorical	4
Numeric	9

Alerts

Dataset has 5 (0.5%) duplicate rows	Duplicates
`Date` has a high cardinality: 136 distinct values	High cardinality
`region` has a high cardinality: 54 distinct values	High cardinality
`AveragePrice` is highly overall correlated with `Total Volume` and 8 other fields	High correlation
`Total Volume` is highly overall correlated with `AveragePrice` and 7 other fields	High correlation
`4046` is highly overall correlated with `AveragePrice` and 7 other fields	High correlation
`4225` is highly overall correlated with `AveragePrice` and 7 other fields	High correlation
`4770` is highly overall correlated with `AveragePrice` and 6 other fields	High correlation
`Total Bags` is highly overall correlated with `AveragePrice` and 7 other fields	High correlation
`Small Bags` is highly overall correlated with `AveragePrice` and 7 other fields	High correlation
`Large Bags` is highly overall correlated with `AveragePrice` and 5 other fields	High correlation
`XLarge Bags` is highly overall correlated with `AveragePrice` and 6 other fields	High correlation
`type` is highly overall correlated with `AveragePrice`	High correlation
`4770` has 237 (23.7%) zeros	Zeros
`Large Bags` has 249 (24.9%) zeros	Zeros
`XLarge Bags` has 704 (70.4%) zeros	Zeros

Reproduction

Analysis started	2023-03-29 13:41:53.473322
Analysis finished	2023-03-29 13:42:07.862540
Duration	14.39 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

Date
Categorical

Distinct	136
Distinct (%)	13.6%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

2016-07-31	73
2015-11-01	62
2016-06-19	42
2015-12-20	37
2015-01-11	20
Other values (131)	766

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	10000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	2015-07-05
2nd row	2015-06-07
3rd row	2015-01-18
4th row	2015-04-05
5th row	2016-10-16

Common Values

Value	Count	Frequency (%)
2016-07-31	73	7.3%
2015-11-01	62	6.2%
2016-06-19	42	4.2%
2015-12-20	37	3.7%
2015-01-11	20	2.0%
2015-04-05	13	1.3%
2015-01-04	12	1.2%
2015-03-22	10	1.0%
2015-07-19	10	1.0%
2016-02-07	10	1.0%
Other values (126)	711	71.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2016-07-31	73	7.3%
2015-11-01	62	6.2%
2016-06-19	42	4.2%
2015-12-20	37	3.7%
2015-01-11	20	2.0%
2015-04-05	13	1.3%
2015-01-04	12	1.2%
2015-03-22	10	1.0%
2015-07-19	10	1.0%
2016-02-07	10	1.0%
Other values (126)	711	71.1%

Most occurring characters

Value	Count	Frequency (%)
0	2204	22.0%
1	2003	20.0%
-	2000	20.0%
2	1503	15.0%
5	628	6.3%
6	561	5.6%
7	385	3.9%
3	265	2.6%
4	166	1.7%
9	159	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8000	80.0%
Dash Punctuation	2000	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2204	27.6%
1	2003	25.0%
2	1503	18.8%
5	628	7.8%
6	561	7.0%
7	385	4.8%
3	265	3.3%
4	166	2.1%
9	159	2.0%
8	126	1.6%

Dash Punctuation

Value	Count	Frequency (%)
-	2000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2204	22.0%
1	2003	20.0%
-	2000	20.0%
2	1503	15.0%
5	628	6.3%
6	561	5.6%
7	385	3.9%
3	265	2.6%
4	166	1.7%
9	159	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2204	22.0%
1	2003	20.0%
-	2000	20.0%
2	1503	15.0%
5	628	6.3%
6	561	5.6%
7	385	3.9%
3	265	2.6%
4	166	1.7%
9	159	1.6%

AveragePrice
Real number (ℝ)

Distinct	173
Distinct (%)	17.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.41973

Minimum	0.46
Maximum	2.75
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0.46
5-th percentile	0.8495
Q1	1.07
median	1.365
Q3	1.81
95-th percentile	2.0205
Maximum	2.75
Range	2.29
Interquartile range (IQR)	0.74

Descriptive statistics

Standard deviation	0.41809428
Coefficient of variation (CV)	0.29448859
Kurtosis	-0.55525463
Mean	1.41973
Median Absolute Deviation (MAD)	0.345
Skewness	0.370147
Sum	1419.73
Variance	0.17480283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.02	65	6.5%
1.82	58	5.8%
0.99	52	5.2%
1.23	44	4.4%
1.85	16	1.6%
1.11	13	1.3%
1.87	13	1.3%
0.98	12	1.2%
1.38	12	1.2%
1.19	12	1.2%
Other values (163)	703	70.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.46	1	0.1%
0.51	1	0.1%
0.56	2	0.2%
0.57	1	0.1%
0.58	1	0.1%
0.6	2	0.2%
0.63	1	0.1%
0.65	3	0.3%
0.68	2	0.2%
0.72	2	0.2%

Value	Count	Frequency (%)
2.75	1	0.1%
2.73	1	0.1%
2.72	2	0.2%
2.65	1	0.1%
2.63	1	0.1%
2.59	1	0.1%
2.51	1	0.1%
2.48	1	0.1%
2.46	1	0.1%
2.41	1	0.1%

Total Volume
Real number (ℝ)

Distinct	801
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	749914.07

Minimum	385.55
Maximum	37130689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	385.55
5-th percentile	1958.1395
Q1	8647.5025
median	87961.135
Q3	453747.33
95-th percentile	3666657.1
Maximum	37130689
Range	37130303
Interquartile range (IQR)	445099.83

Descriptive statistics

Standard deviation	2791606.2
Coefficient of variation (CV)	3.7225681
Kurtosis	108.13685
Mean	749914.07
Median Absolute Deviation (MAD)	85852.095
Skewness	9.5940705
Sum	7.4991407 × 10⁸
Variance	7.793065 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14788.87	64	6.4%
2109.04	55	5.5%
278178.65	41	4.1%
1139347.98	32	3.2%
1614.56	12	1.2%
115579.5	1	0.1%
1275952.93	1	0.1%
9140.79	1	0.1%
261084.13	1	0.1%
7867.61	1	0.1%
Other values (791)	791	79.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
385.55	1	0.1%
515.01	1	0.1%
593.39	1	0.1%
761.86	1	0.1%
792.97	1	0.1%
858.83	1	0.1%
872.07	1	0.1%
964.25	1	0.1%
979.74	1	0.1%
1014.02	1	0.1%

Value	Count	Frequency (%)
37130688.91	1	0.1%
35734613.9	1	0.1%
33254911.87	1	0.1%
32994014.16	1	0.1%
30652211.08	1	0.1%
26240072.11	1	0.1%
9032180.67	1	0.1%
7707711.9	1	0.1%
7661483.37	1	0.1%
7281887.35	1	0.1%

4046
Real number (ℝ)

Distinct	795
Distinct (%)	79.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	261937.71

Minimum	0
Maximum	14699605
Zeros	7
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	37.5355
Q1	895.68
median	6212.92
Q3	76788.78
95-th percentile	1376986.9
Maximum	14699605
Range	14699605
Interquartile range (IQR)	75893.1

Descriptive statistics

Standard deviation	1133462.4
Coefficient of variation (CV)	4.3272213
Kurtosis	99.984644
Mean	261937.71
Median Absolute Deviation (MAD)	6195.635
Skewness	9.1416408
Sum	2.6193771 × 10⁸
Variance	1.2847371 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
895.68	64	6.4%
1331.43	55	5.5%
67619.73	41	4.1%
13998.35	32	3.2%
1091.28	12	1.2%
0	7	0.7%
18600.18	1	0.1%
2.48	1	0.1%
131414.8	1	0.1%
4161.89	1	0.1%
Other values (785)	785	78.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	0.7%
1.24	1	0.1%
2.48	1	0.1%
2.59	1	0.1%
3.64	1	0.1%
4.77	1	0.1%
4.82	1	0.1%
4.98	1	0.1%
5.04	1	0.1%
5.05	1	0.1%

Value	Count	Frequency (%)
14699604.93	1	0.1%
14643465.52	1	0.1%
13282222.98	1	0.1%
13003371.07	1	0.1%
12196225.93	1	0.1%
8683958.8	1	0.1%
4794142.14	1	0.1%
4075881.34	1	0.1%
3851189.34	1	0.1%
3666928.36	1	0.1%

4225
Real number (ℝ)

Distinct	801
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	284227.4

Minimum	0
Maximum	13926693
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	21.71
Q1	2726.44
median	26918.375
Q3	146266.21
95-th percentile	1177740.5
Maximum	13926693
Range	13926693
Interquartile range (IQR)	143539.77

Descriptive statistics

Standard deviation	1065258.7
Coefficient of variation (CV)	3.7479098
Kurtosis	109.73567
Mean	284227.4
Median Absolute Deviation (MAD)	26868.425
Skewness	9.7224985
Sum	2.842274 × 10⁸
Variance	1.134776 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10096.25	64	6.4%
21.71	55	5.5%
122627.22	41	4.1%
867406.68	32	3.2%
49.95	12	1.2%
67122.02	1	0.1%
714407.25	1	0.1%
154.07	1	0.1%
84541.6	1	0.1%
2885.72	1	0.1%
Other values (791)	791	79.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
1.26	1	0.1%
3.45	1	0.1%
5.8	1	0.1%
5.92	1	0.1%
6.26	1	0.1%
6.42	1	0.1%
7.16	1	0.1%
7.19	1	0.1%
8.76	1	0.1%

Value	Count	Frequency (%)
13926692.62	1	0.1%
13733124.48	1	0.1%
13244466.6	1	0.1%
12009228.05	1	0.1%
11410478.34	1	0.1%
11083513.46	1	0.1%
3517891.27	1	0.1%
3460743.8	1	0.1%
3361015.9	1	0.1%
2896879.68	1	0.1%

4770
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	576
Distinct (%)	57.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20267.923

Minimum	0
Maximum	1326422.6
Zeros	237
Zeros (%)	23.7%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4.445
median	495.8
Q3	8544.8875
95-th percentile	97885.241
Maximum	1326422.6
Range	1326422.6
Interquartile range (IQR)	8540.4425

Descriptive statistics

Standard deviation	93649.678
Coefficient of variation (CV)	4.6205857
Kurtosis	106.80288
Mean	20267.923
Median Absolute Deviation (MAD)	495.8
Skewness	9.5605068
Sum	20267923
Variance	8.7702621 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	237	23.7%
495.8	64	6.4%
12.57	55	5.5%
15409.3	41	4.1%
803.83	32	3.2%
367.91	1	0.1%
14380.96	1	0.1%
905.77	1	0.1%
12917.42	1	0.1%
36.04	1	0.1%
Other values (566)	566	56.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	237	23.7%
1.44	1	0.1%
1.58	1	0.1%
2.63	1	0.1%
2.73	1	0.1%
2.74	1	0.1%
2.91	1	0.1%
3.08	1	0.1%
3.22	1	0.1%
3.32	1	0.1%

Value	Count	Frequency (%)
1326422.56	1	0.1%
1188118.95	1	0.1%
1070576.07	1	0.1%
1017157.74	1	0.1%
1014520.88	1	0.1%
697833.12	1	0.1%
556972.27	1	0.1%
540680.89	1	0.1%
356022.1	1	0.1%
352247.15	1	0.1%

Total Bags
Real number (ℝ)

Distinct	801
Distinct (%)	80.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	183477.1

Minimum	0
Maximum	10863029
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	521.3105
Q1	3301.14
median	33113.605
Q3	106308.4
95-th percentile	930244.17
Maximum	10863029
Range	10863029
Interquartile range (IQR)	103007.26

Descriptive statistics

Standard deviation	604482.27
Coefficient of variation (CV)	3.2945924
Kurtosis	127.38009
Mean	183477.1
Median Absolute Deviation (MAD)	32370.275
Skewness	9.5254951
Sum	1.834771 × 10⁸
Variance	3.6539881 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3301.14	64	6.4%
743.33	55	5.5%
72522.4	41	4.1%
257139.12	32	3.2%
473.33	12	1.2%
41505.82	1	0.1%
529895.86	1	0.1%
8984.24	1	0.1%
40566.09	1	0.1%
820	1	0.1%
Other values (791)	791	79.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
12.94	1	0.1%
25.15	1	0.1%
40	1	0.1%
40.19	1	0.1%
45.84	1	0.1%
59.12	1	0.1%
80.97	1	0.1%
109.47	1	0.1%
136.18	1	0.1%

Value	Count	Frequency (%)
10863029.04	1	0.1%
6464119.81	1	0.1%
5429599.36	1	0.1%
5310327.3	1	0.1%
4957516.02	1	0.1%
4908090.63	1	0.1%
2868822.6	1	0.1%
2707752.65	1	0.1%
2285895.6	1	0.1%
2246865.14	1	0.1%

Small Bags
Real number (ℝ)

Distinct	790
Distinct (%)	79.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	143267.44

Minimum	0
Maximum	8555283.7
Zeros	5
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	263.349
Q1	1666.1775
median	20016.585
Q3	81615.28
95-th percentile	695997.32
Maximum	8555283.7
Range	8555283.7
Interquartile range (IQR)	79949.102

Descriptive statistics

Standard deviation	487250.35
Coefficient of variation (CV)	3.4009846
Kurtosis	124.12477
Mean	143267.44
Median Absolute Deviation (MAD)	19546.585
Skewness	9.5296762
Sum	1.4326744 × 10⁸
Variance	2.374129 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3301.14	64	6.4%
743.33	55	5.5%
67694	41	4.1%
212615.2	32	3.2%
473.33	12	1.2%
0	5	0.5%
286.67	2	0.2%
916.67	2	0.2%
143.33	2	0.2%
330	2	0.2%
Other values (780)	783	78.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	0.5%
3.33	1	0.1%
7.43	1	0.1%
12.94	1	0.1%
25.15	1	0.1%
26.67	1	0.1%
30	2	0.2%
40	1	0.1%
40.19	1	0.1%
40.46	1	0.1%

Value	Count	Frequency (%)
8555283.68	1	0.1%
5517909.51	1	0.1%
4627251.87	1	0.1%
4391461.66	1	0.1%
4129138.63	1	0.1%
3918658.43	1	0.1%
2122673.09	1	0.1%
1911608.83	1	0.1%
1722082.22	1	0.1%
1665446.71	1	0.1%

Large Bags
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	670
Distinct (%)	67.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38216.978

Minimum	0
Maximum	2214419.3
Zeros	249
Zeros (%)	24.9%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2.445
median	1066.285
Q3	17323.568
95-th percentile	185715.35
Maximum	2214419.3
Range	2214419.3
Interquartile range (IQR)	17321.123

Descriptive statistics

Standard deviation	134768.51
Coefficient of variation (CV)	3.5264041
Kurtosis	95.462004
Mean	38216.978
Median Absolute Deviation (MAD)	1066.285
Skewness	8.2837023
Sum	38216978
Variance	1.816255 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	249	24.9%
83.4	41	4.1%
44523.92	32	3.2%
3.33	7	0.7%
23.33	3	0.3%
6.67	3	0.3%
43.33	2	0.2%
10017.28	1	0.1%
11396.65	1	0.1%
31781.23	1	0.1%
Other values (660)	660	66.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	249	24.9%
1.83	1	0.1%
2.65	1	0.1%
2.75	1	0.1%
3.08	1	0.1%
3.33	7	0.7%
3.79	1	0.1%
3.97	1	0.1%
4.44	1	0.1%
4.71	1	0.1%

Value	Count	Frequency (%)
2214419.29	1	0.1%
1352291.24	1	0.1%
1320163.95	1	0.1%
1003906.67	1	0.1%
999727.7	1	0.1%
898027.46	1	0.1%
888237.91	1	0.1%
779807.55	1	0.1%
725218.35	1	0.1%
696042.61	1	0.1%

XLarge Bags
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	255
Distinct (%)	25.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1992.6885

Minimum	0
Maximum	93326.07
Zeros	704
Zeros (%)	70.4%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	50.86
95-th percentile	10313.553
Maximum	93326.07
Range	93326.07
Interquartile range (IQR)	50.86

Descriptive statistics

Standard deviation	7250.8038
Coefficient of variation (CV)	3.6387041
Kurtosis	47.868771
Mean	1992.6885
Median Absolute Deviation (MAD)	0
Skewness	6.1507956
Sum	1992688.5
Variance	52574155
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	704	70.4%
4745	42	4.2%
2.85	2	0.2%
134.72	1	0.1%
3161.37	1	0.1%
4025	1	0.1%
1363.39	1	0.1%
26022.01	1	0.1%
40842.24	1	0.1%
3875.64	1	0.1%
Other values (245)	245	24.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	704	70.4%
1.87	1	0.1%
2.25	1	0.1%
2.7	1	0.1%
2.85	2	0.2%
3.06	1	0.1%
3.09	1	0.1%
3.22	1	0.1%
3.24	1	0.1%
3.39	1	0.1%

Value	Count	Frequency (%)
93326.07	1	0.1%
64348.68	1	0.1%
54249.87	1	0.1%
53733.65	1	0.1%
48182.84	1	0.1%
47983.17	1	0.1%
46909.66	1	0.1%
46466.7	1	0.1%
45140.96	1	0.1%
44790.27	1	0.1%

type
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

organic	513
conventional	487

Length

Max length	12
Median length	7
Mean length	9.435
Min length	7

Characters and Unicode

Total characters	9435
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	conventional
2nd row	organic
3rd row	organic
4th row	conventional
5th row	organic

Common Values

Value	Count	Frequency (%)
organic	513	51.3%
conventional	487	48.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
organic	513	51.3%
conventional	487	48.7%

Most occurring characters

Value	Count	Frequency (%)
n	1974	20.9%
o	1487	15.8%
a	1000	10.6%
i	1000	10.6%
c	1000	10.6%
r	513	5.4%
g	513	5.4%
v	487	5.2%
e	487	5.2%
t	487	5.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9435	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	1974	20.9%
o	1487	15.8%
a	1000	10.6%
i	1000	10.6%
c	1000	10.6%
r	513	5.4%
g	513	5.4%
v	487	5.2%
e	487	5.2%
t	487	5.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9435	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	1974	20.9%
o	1487	15.8%
a	1000	10.6%
i	1000	10.6%
c	1000	10.6%
r	513	5.4%
g	513	5.4%
v	487	5.2%
e	487	5.2%
t	487	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9435	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	1974	20.9%
o	1487	15.8%
a	1000	10.6%
i	1000	10.6%
c	1000	10.6%
r	513	5.4%
g	513	5.4%
v	487	5.2%
e	487	5.2%
t	487	5.2%

year
Categorical

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

2015	437
2016	390
2017	173

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	4000
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2015
2nd row	2015
3rd row	2015
4th row	2015
5th row	2016

Common Values

Value	Count	Frequency (%)
2015	437	43.7%
2016	390	39.0%
2017	173	17.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2015	437	43.7%
2016	390	39.0%
2017	173	17.3%

Most occurring characters

Value	Count	Frequency (%)
2	1000	25.0%
0	1000	25.0%
1	1000	25.0%
5	437	10.9%
6	390	9.8%
7	173	4.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1000	25.0%
0	1000	25.0%
1	1000	25.0%
5	437	10.9%
6	390	9.8%
7	173	4.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	4000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1000	25.0%
0	1000	25.0%
1	1000	25.0%
5	437	10.9%
6	390	9.8%
7	173	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1000	25.0%
0	1000	25.0%
1	1000	25.0%
5	437	10.9%
6	390	9.8%
7	173	4.3%

region
Categorical

Distinct	54
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

BaltimoreWashington	76
RichmondNorfolk	64
Jacksonville	62
NewYork	51
MiamiFtLauderdale	28
Other values (49)	719

Length

Max length	19
Median length	15
Mean length	11.039
Min length	4

Characters and Unicode

Total characters	11039
Distinct characters	45
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pittsburgh
2nd row	BuffaloRochester
3rd row	MiamiFtLauderdale
4th row	SanFrancisco
5th row	BaltimoreWashington

Common Values

Value	Count	Frequency (%)
BaltimoreWashington	76	7.6%
RichmondNorfolk	64	6.4%
Jacksonville	62	6.2%
NewYork	51	5.1%
MiamiFtLauderdale	28	2.8%
Pittsburgh	24	2.4%
West	24	2.4%
Boise	21	2.1%
SouthCentral	20	2.0%
NewOrleansMobile	20	2.0%
Other values (44)	610	61.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
baltimorewashington	76	7.6%
richmondnorfolk	64	6.4%
jacksonville	62	6.2%
newyork	51	5.1%
miamiftlauderdale	28	2.8%
pittsburgh	24	2.4%
west	24	2.4%
boise	21	2.1%
southcentral	20	2.0%
neworleansmobile	20	2.0%
Other values (44)	610	61.0%

Most occurring characters

Value	Count	Frequency (%)
o	1058	9.6%
a	1015	9.2%
e	832	7.5%
n	785	7.1%
i	759	6.9%
t	732	6.6%
l	695	6.3%
r	659	6.0%
s	555	5.0%
h	375	3.4%
Other values (35)	3574	32.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9423	85.4%
Uppercase Letter	1616	14.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1058	11.2%
a	1015	10.8%
e	832	8.8%
n	785	8.3%
i	759	8.1%
t	732	7.8%
l	695	7.4%
r	659	7.0%
s	555	5.9%
h	375	4.0%
Other values (13)	1958	20.8%

Uppercase Letter

Value	Count	Frequency (%)
N	194	12.0%
S	194	12.0%
B	130	8.0%
R	125	7.7%
W	120	7.4%
C	103	6.4%
L	96	5.9%
P	86	5.3%
M	68	4.2%
D	65	4.0%
Other values (12)	435	26.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11039	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1058	9.6%
a	1015	9.2%
e	832	7.5%
n	785	7.1%
i	759	6.9%
t	732	6.6%
l	695	6.3%
r	659	6.0%
s	555	5.0%
h	375	3.4%
Other values (35)	3574	32.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11039	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1058	9.6%
a	1015	9.2%
e	832	7.5%
n	785	7.1%
i	759	6.9%
t	732	6.6%
l	695	6.3%
r	659	6.0%
s	555	5.0%
h	375	3.4%
Other values (35)	3574	32.4%

Auto

Heatmap
Table

	AveragePrice	Total Volume	4046	4225	4770	Total Bags	Small Bags	Large Bags	XLarge Bags	type	year	region
AveragePrice	1.000	-0.695	-0.682	-0.600	-0.529	-0.707	-0.639	-0.584	-0.518	0.734	0.243	0.399
Total Volume	-0.695	1.000	0.862	0.957	0.790	0.960	0.931	0.728	0.606	0.225	0.000	0.377
4046	-0.682	0.862	1.000	0.765	0.712	0.815	0.807	0.616	0.613	0.222	0.000	0.380
4225	-0.600	0.957	0.765	1.000	0.794	0.891	0.869	0.672	0.588	0.200	0.049	0.432
4770	-0.529	0.790	0.712	0.794	1.000	0.735	0.770	0.440	0.652	0.167	0.068	0.273
Total Bags	-0.707	0.960	0.815	0.891	0.735	1.000	0.956	0.777	0.604	0.191	0.115	0.358
Small Bags	-0.639	0.931	0.807	0.869	0.770	0.956	1.000	0.631	0.620	0.189	0.109	0.315
Large Bags	-0.584	0.728	0.616	0.672	0.440	0.777	0.631	1.000	0.390	0.167	0.072	0.237
XLarge Bags	-0.518	0.606	0.613	0.588	0.652	0.604	0.620	0.390	1.000	0.236	0.099	0.211
type	0.734	0.225	0.222	0.200	0.167	0.191	0.189	0.167	0.236	1.000	0.000	0.409
year	0.243	0.000	0.000	0.049	0.068	0.115	0.109	0.072	0.099	0.000	1.000	0.334
region	0.399	0.377	0.380	0.432	0.273	0.358	0.315	0.237	0.211	0.409	0.334	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Date	AveragePrice	Total Volume	4046	4225	4770	Total Bags	Small Bags	Large Bags	XLarge Bags	type	year	region
0	2015-07-05	1.23	115579.50	1635.60	67122.02	5316.06	41505.82	31488.54	10017.28	0.00	conventional	2015	Pittsburgh
1	2015-06-07	1.80	4777.04	45.84	167.38	0.00	4563.82	4563.82	0.00	0.00	organic	2015	BuffaloRochester
2	2015-01-18	1.87	1459.37	1054.78	17.92	0.00	386.67	386.67	0.00	0.00	organic	2015	MiamiFtLauderdale
3	2015-04-05	1.33	742539.71	143671.36	473142.55	35650.70	90075.10	88603.82	1025.45	445.83	conventional	2015	SanFrancisco
4	2016-10-16	1.95	16843.53	824.95	9095.02	680.30	6243.26	6226.14	17.12	0.00	organic	2016	BaltimoreWashington
5	2015-01-04	0.94	461607.33	244152.26	165299.33	15302.75	36852.99	30884.29	5595.00	373.70	conventional	2015	SanDiego
6	2015-07-05	1.98	29929.57	8841.34	20807.76	280.47	0.00	0.00	0.00	0.00	organic	2015	Seattle
7	2016-08-14	1.48	9978.31	899.71	4522.42	0.00	4556.18	2277.22	2278.96	0.00	organic	2016	Nashville
8	2015-08-23	1.72	11555.75	4288.75	3541.08	635.31	3090.61	3087.86	2.75	0.00	organic	2015	BaltimoreWashington
9	2016-10-09	1.29	89506.29	24596.38	27239.36	953.05	36717.50	32322.38	4395.12	0.00	conventional	2016	Pittsburgh

	Date	AveragePrice	Total Volume	4046	4225	4770	Total Bags	Small Bags	Large Bags	XLarge Bags	type	year	region
990	2017-07-09	1.52	101331.41	2899.46	81929.02	494.51	16008.42	8213.25	5210.17	2585.00	conventional	2017	Albany
991	2016-06-19	0.99	278178.65	67619.73	122627.22	15409.30	72522.40	67694.00	83.40	4745.00	conventional	2016	RichmondNorfolk
992	2016-03-27	1.40	3215.76	101.00	1477.50	0.00	1637.26	663.33	973.93	0.00	organic	2016	Indianapolis
993	2015-01-04	1.81	1339.36	754.00	124.33	0.00	461.03	447.01	14.02	0.00	organic	2015	Pittsburgh
994	2016-03-20	0.74	3374876.94	928106.16	901464.72	91298.87	1454007.19	1301235.10	134711.21	18060.88	conventional	2016	LosAngeles
995	2015-11-01	1.82	2109.04	1331.43	21.71	12.57	743.33	743.33	0.00	0.00	organic	2015	Jacksonville
996	2016-07-31	2.02	14788.87	895.68	10096.25	495.80	3301.14	3301.14	0.00	0.00	organic	2016	BaltimoreWashington
997	2015-11-08	1.40	4144.82	443.10	2827.56	0.00	874.16	413.97	460.19	0.00	organic	2015	Columbus
998	2015-12-13	0.95	407482.83	2970.12	369076.25	116.84	35319.62	35319.62	0.00	0.00	conventional	2015	NorthernNewEngland
999	2015-11-01	1.82	2109.04	1331.43	21.71	12.57	743.33	743.33	0.00	0.00	organic	2015	Jacksonville

Most frequently occurring

	Date	AveragePrice	Total Volume	4046	4225	4770	Total Bags	Small Bags	Large Bags	XLarge Bags	type	year	region	# duplicates
4	2016-07-31	2.02	14788.87	895.68	10096.25	495.80	3301.14	3301.14	0.00	0.0	organic	2016	BaltimoreWashington	64
1	2015-11-01	1.82	2109.04	1331.43	21.71	12.57	743.33	743.33	0.00	0.0	organic	2015	Jacksonville	55
3	2016-06-19	0.99	278178.65	67619.73	122627.22	15409.30	72522.40	67694.00	83.40	4745.0	conventional	2016	RichmondNorfolk	41
2	2015-12-20	1.23	1139347.98	13998.35	867406.68	803.83	257139.12	212615.20	44523.92	0.0	conventional	2015	NewYork	32
0	2015-01-11	1.85	1614.56	1091.28	49.95	0.00	473.33	473.33	0.00	0.0	organic	2015	MiamiFtLauderdale	12

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring